-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
Create PROCEDURE [dbo].[DeleteMax]
AS
BEGIN
	SET NOCOUNT ON;

	DECLARE @EmpKey INT;
	
	SELECT @EmpKey = MAX([EmployeeKey]) FROM [dbo].[DimEmployee]
	
	DELETE [dbo].[DimEmployee] WHERE [EmployeeKey] = @EmpKey

END

